- 01. Learning Objective
- 02. Databases
- 03. Importance of Relational Databases
- 04. OLAP vs OLTP
- 05. Quiz 1
- 06. Structuring the Database: Normalization
- 07. Objectives of Normal Form
- 08. Normal Forms
- 09. Demo 1: Creating Normalized Tables
- 10. Exercise 1: Creating Normalized Tables
- 11. Solution: Exercise 1: Creating Normalized Tables
- 12. Denormalization
- 13. Demo 2: Creating Denormalized Tables
- 14. Denormalization Vs. Normalization
- 15. Exercise 2: Creating Denormalized Tables
- 16. Solution: Exercise 2: Creating Denormalized Tables
- 17. Fact and Dimension Tables
- 18. Star Schemas
- 19. Benefits of Star Schemas
- 20. Snowflake Schemas
- 21. Demo 3: Creating Fact and Dimension Tables
- 22. Exercise 3: Creating Fact and Dimension Tables
- 23. Solution: Exercise 3: Creating Fact and Dimension Tables
- 24. Data Definition and Constraints
- 25. Upsert
- 26. Conclusion